SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
DELETE
FROM jos_session
WHERE ( time < '1268278980' )
SELECT *
FROM jos_session
WHERE session_id = 'f7394325c31421adcc5f268e2b36b610'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'f7394325c31421adcc5f268e2b36b610','1268279880','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT id
FROM jos_core_acl_aro_groups
WHERE name = ''
SELECT `file`, `params`
FROM `jos_sefexts`
SELECT *
FROM jos_sefurls
WHERE ((`sefurl` = 'component/remository/Veritabani/[e-book]sadettin_polat-sql.rar') OR (`sefurl` = 'component/remository/Veritabani/[e-book]sadettin_polat-sql.rar/'))
AND (`origurl` != '')
ORDER BY `priority`
LIMIT 1
SELECT *
FROM `jos_sefmoved`
WHERE (`old` = 'component/remository/Veritabani/[e-book]sadettin_polat-sql.rar') OR (`old` = 'component/remository/Veritabani/[e-book]sadettin_polat-sql.rar/')
SELECT *
FROM jos_downloads_repository
ORDER BY id
LIMIT 1
SELECT *
FROM jos_downloads_containers
ORDER BY sequence, name
SELECT f.id, f.containerid, f.filetitle, f.realname
FROM jos_downloads_files AS f
WHERE f.containerid = 12
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT role, subject_id, action
FROM jos_permissions
WHERE subject_type = 'remosFolder'
AND action IN('download','edit')
SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count
FROM jos_downloads_files AS f
LEFT JOIN jos_downloads_log AS l
ON l.type=3
AND l.fileid=f.id
WHERE f.id = 140
AND published=1
GROUP BY f.id
SELECT COUNT(*)
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='download' OR `action`='*')
SELECT `role`, `control`, `subject_id`, `action`
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='download' OR `action`='*')
SELECT fileid, COUNT(fileid) AS number
FROM jos_downloads_log
WHERE type = 1
AND ipaddress = '38.107.191.86'
AND date > SUBDATE(NOW(), INTERVAL 24 HOUR)
GROUP BY fileid
SELECT id
FROM jos_downloads_files
WHERE (submitdate > '2009-09-11 09:19:36' OR ('2009-09-11 09:19:36' = submitdate
AND id < 140))
ORDER BY submitdate DESC, id DESC
LIMIT 1
SELECT id
FROM jos_downloads_files
WHERE (submitdate < '2009-09-11 09:19:36' OR ('2009-09-11 09:19:36' = submitdate
AND id > 140))
ORDER BY submitdate DESC, id
LIMIT 1
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT COUNT(*)
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='edit' OR `action`='*')
SELECT `role`, `control`, `subject_id`, `action`
FROM `jos_permissions`
WHERE `subject_type`='remosFolder'
AND (`action`='edit' OR `action`='*')
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_remository.xml'
LIMIT 1
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder
FROM jos_menu
WHERE link LIKE 'index.php?option=com_remository%'
AND published=1
ORDER BY menorder
SELECT *
FROM jos_users
WHERE id = '62'
SELECT role, access_id
FROM jos_assignments AS a
WHERE a.access_type='aUser'
AND (a.access_id='62' OR a.access_id='*' OR a.access_id='+')
SELECT c.id, c.title, c.comment, c.date, u.id AS userid, u.name, u.username
FROM jos_downloads_reviews AS c
INNER JOIN jos_users AS u
ON c.userid=u.id
WHERE c.itemid=140
SELECT c.*, CASE WHEN c.type = '' THEN 0 ELSE 9 END AS typseq
FROM jos_downloads_classify AS c
INNER JOIN jos_downloads_file_classify AS fc
ON c.id = fc.classify_id
WHERE c.published != 0
AND c.hidden = 0
AND fc.file_id = 140
ORDER BY typseq, c.name
SELECT menutype, id, name, link
FROM jos_menu
WHERE id = 0
AND link LIKE '%com_remository%'
SELECT *
FROM jos_ijseo_metags
WHERE id = 0
AND name = ''
SELECT *
FROM jos_ijseo_metags
WHERE id = 0
AND name = ''
SELECT *
FROM jos_ijseo_metags
WHERE id = 140
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_ijseo_metags
WHERE id = 140
AND mtype = 'virtuemart-prod'
SELECT *
FROM jos_menu
WHERE home = '1'
ORDER BY ordering
LIMIT 1
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&view=frontpage'
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_content.xml'
LIMIT 1
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=48&view=category'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=51&view=category'
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_alphacontent.xml'
LIMIT 1
SELECT `catid`
FROM `jos_content`
WHERE `id` = '46'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=50&view=category'
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_content&id=47&view=category'
SELECT `catid`
FROM `jos_content`
WHERE `id` = '179'
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_contact.xml'
LIMIT 1
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 0 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_googleSearch_conf
LIMIT 1
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_googlesearch%'
LIMIT 1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND catid = 14
ORDER BY sticky DESC, ordering
LIMIT 0, 7
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 14
SELECT `filters`
FROM `jos_sefexts`
WHERE `file` = 'com_banners.xml'
LIMIT 1
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=14&task=click'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 37
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 13
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=13&task=click'
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 33
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 12
SELECT `sefurl`, `Itemid`
FROM `jos_sefurls`
WHERE `origurl` = 'index.php?option=com_banners&bid=12&task=click'
İndir
Toplam Oy:0